2015-02-16 - Spec - 10735 - Add a new field to the order entry sheet - (Dan by 2015-02-18) #JapanSD #OrderEntry #JapanABAP #APAC
SPECIFICATIONS
10735 - Spec - Add a new field to the order entry sheet
Purpose
Business requested to add a new field "Valid from" date to the order entry sheet for contract creation.
Admin Info
Purpose
|
Business requested to add a new field "Valid from" date to the order entry sheet for contract creation
|
Requested By
|
Daniel Brennan
|
Spec Created By
|
Surya Basa
|
Spec Created Date
|
02/17/2015
|
Spec QA by
|
Surya Basa
|
Objects
|
ZSD_JPN_ORD_SHT_MULTIPLE
|
Document Status
|
WIP
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
04
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
02
|
6
|
Other activity
|
NA
|
|
TOTAL
|
13
|
References
Prior Tickets
2014-11-24 - 10735 - Spec - New Era Japan IT Deployment - Sales Order Creation from Order Sheet
2014-12-22 - 10735 - Spec - Contract and Sales Order Creation from Order Sheet with Multiple Tabs - (Dan B by 2015-01-29)
Documents
Example sheet with Valid from date field-
CONTRACTS1.xlsx
Spec Changes
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Update the program to adding a new field - 'Requested Delivery Date' in the order entry sheet for Contract.
|
Dan Brennan
|
02/09/2015
|
NA
|
2
|
Update the program to throw error message if the all the quantity fields are blank
|
Dan Brennan
|
02/16/2015
|
NA
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Business has requested to add a new field-valid from date to the order entry sheet for contract creation.
In Scope:
- The changes are applicable to contract creation program only.
- Error message should be shown if the order entry sheet has all blank quantity fields.
Out of Scope:
Existing functionality is not changed for the order creation program.
Solution Summary
- The programs should be updated to check for additional field "Valid from date" on the order sheet which is a mandatory filed
- Validation for the quantity field should be applied and in case of blank, error message should be displayed for the particular item/line #.
Test Plan
Below are the scenarios can be tested for the above changes.
Test ID
|
Test Scenarios
|
Expected Results
|
SD0218-01
|
Fill the order sheet with missing valid from date. Upload into the sell sheet program and execute it.
|
Contract should be created and valid from date should be document creation date.
|
SD0218-02
|
Fill the order sheet with valid from date beyond the RDD. And upload into the sell sheet program and execute it.
|
Contract should not be created and appropriate system message should be displayed.
|
SD0218-03
|
Fill the order sheet with valid from date lessthan or equal to RDD and protect the sheet. And upload into the sell sheet program and execute it.
|
Contract should be created with the given Valid from date.
|
SD0218-04
|
Fill the order sheet with multiple sheets.
|
Contract should be created for sheet 1, and sheet 2 with document creation date and appropriate system message should be displayed for sheet 3.
|
Sheet1- OK data
|
Sheet2- Missing Valid from date
|
Sheet3- Valid from date is beyond RDD
|
SD0218-05
|
Fill the order sheet with quantity as blank for all items. And upload the excel sheet into the program and execute it.
|
Contract should not be created and error message 'Check Quantity' should come following the sheet number given in excel file.
|
SD0218-06
|
Fill the order sheet with multiple sheets as below.
|
Contract should be created for sheet 1, & 3 (item 1,2) and appropriate system message should be displayed for sheet 2.
|
Sheet 1 - Ok Data
|
Sheet 2- Qty blank for all items
|
Sheet 3 - Item 1,2 - Ok Data & item 3 - Qty Blank
|
Solution Details
[Provide complete technical details for configuration or programming here]
Issues
[List Issues / Bugs identified in configuration or development]
NA